i got mysql error on this statement i don't know why [closed]

Posted by John Smiith on Pro Webmasters See other posts from Pro Webmasters or by John Smiith
Published on 2012-09-16T11:01:14Z Indexed on 2012/09/16 15:52 UTC
Read the original article Hit count: 197

Filed under:
|

i got mysql error on this statement i don't know why error is:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT fk_objet_code FOREIGN KEY (objet_code) REFERENCES objet(code) ) ENG' at line 6

sql code is

CREATE TABLE IF NOT EXISTS `class` (
  `numero` int(11) NOT NULL AUTO_INCREMENT,
  `type_class` varchar(100) DEFAULT NULL,
  `images` varchar(200) NOT NULL,
  PRIMARY KEY (`numero`)
  CONSTRAINT fk_objet_code FOREIGN KEY (objet_code) REFERENCES objet(code) 
)  ENGINE=InnoDB;;

© Pro Webmasters or respective owner

Related posts about mysql

Related posts about phpmyadmin